Groups module

Vitalware has always enabled users to assign a name to a group of records and subsequently retrieve that group. Users have also been able to add records to a group, allowing a complex set of records to be assembled over time. Information about a group is stored in the egroups table, but until Vitalware 2.0.03 this table was hidden from users and maintained via the Vitalware client: when a user adds to or saves a group, the egroups table is adjusted automatically.

The Groups module was added to Vitalware with version 2.0.03. Now, as well as using the Tools>Group set of menu commands to manage groups (accessible from most modules), users have the option with the Groups module to insert, update and delete groups using a familiar module interface. The Groups module also includes additional functionality: a dynamic Query group (using a TexQL statement) can be created and run in the Groups module; and Record Level Security permissions can be managed.

Three types of groups are supported:

  • Static - a list of record IRNs
  • Terms - a list of columns and associated query terms
  • Query - a TexQL statement

Group permissions use Record Level Security to determine which operations are available for which users. The creator of a group, or someone with permission to alter security settings, can assign other users the permission to manipulate the group. Available permissions are:

  • display - a user can retrieve the group
  • edit - a user can add or replace records in the group
  • delete - a user can delete the group

A Groups module record includes:

  • The name of the group
  • The type of the group (Static, Terms, Query)
  • The source module for records in the group
  • The group owner
  • The IRNs of records in a Static Group; the column name(s) and search terms for a Terms group; the TexQL statement in a Query group.
  • Record Level Security settings for the group

Tip: Details about working with groups can be found in Grouping records.

Related Topics Link IconRelated Topics